package cn.edu.csust.tysp.backend.dao;

import cn.edu.csust.tysp.backend.domain.Sheet;
import cn.edu.csust.tysp.backend.domain.SheetExample;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface SheetMapper {
    long countByExample(SheetExample example);

    int deleteByExample(SheetExample example);

    int deleteByPrimaryKey(Integer id);

    int insert(Sheet record);

    int insertSelective(Sheet record);

    List<Sheet> selectByExample(SheetExample example);

    Sheet selectByPrimaryKey(Integer id);

    int updateByExampleSelective(@Param("record") Sheet record, @Param("example") SheetExample example);

    int updateByExample(@Param("record") Sheet record, @Param("example") SheetExample example);

    int updateByPrimaryKeySelective(Sheet record);

    int updateByPrimaryKey(Sheet record);

    List<Sheet> selectSheet(String sheetName, String instrumentType);

    List<Sheet> selectByName(String sheetName);
}